OPENING QUESTIONS: Please go up to Google Sheets and create a spreadsheet for tracking ALL the Students in this Class. Although that isn't a database, we can still imagine the columns acting like <what?> and the rows would be <what?> and the entire spreadsheet would be <what?>
OBJECTIVES:
I will explore the similarities and differences between spreadsheets and databases during today's class.
WORDS FOR TODAY:
- Big Data - a broad term for datasets so large or complex that traditional data processing applications are inadequate.
- Moore's Law - a predication made by Gordon Moore in 1965 that computing power will double every 1.5-2 years, it has remained more or less true ever since.
- Field - A holder of unique data of a unique data type (For example an AGE field contains integer data that stores a person's age. A field named FNAME would store character data that stores a person's first name
- Record - A "Row" of data related to a specific topic. For example FNAME, LNAME, ADDRESS, CITY, STATE, ZIP would contain data relating to a specific person.
- Table - A "Table" of data contains a bunch of rows of data. For example a spreadsheet is a table of data.
- Database -
WORK O' THE DAY:
Notice how quick and easy it is to setup a spreadsheet?
What are possible pitfalls to treating a spreadsheet like a database?
Let's discuss
What if we wanted to track all the students at GHHS?
What if we wanted to track all the High School students in PSD?
What if we wanted to track all the students in PSD?
What if we wanted to track all the students in Pierce County?
What about the entire state?
The country?
How does PSD link that data?
One of the aspects of databases is that they are scalable.
What do we mean by that?
Let's go take a gander at THIS site. My trial is over and I'm not about to spend $41 a month for that site. But YOU can! (please create your account using your PSD email)